Skip to main content
Version: 4.2.2

Summary

Grid Designer allows users to create grid reports with aggregation functions. This feature not only streamlines the report generation process but also enhances analytical capabilities, enabling organizations to make decisions based on accurate and relevant data. This option can be applied at two levels: with grouped columns or without applying column grouping.

The available aggregation functions that can be added are: Sum, Count, Min, Max, Average.

Summary without Group By​

Grid Designer allows the user to add aggregation functions to grid reports where column grouping has not been applied. These aggregation functions will be displayed at the end of the report as a total.

Steps to Apply Aggregation Functions Without Grouped Columns:​

  1. Open Grid Designer.
  2. Create a new report or open an existing one.
  3. Click on the "Summary" icon.
  4. Right-click at the end of the report on the panel associated with the column to which you want to apply the aggregation functions.
  5. Choose the "Count" option.

The most impressive aspect is that Grid Designer goes further and provides the flexibility you need. This tool not only simplifies the report generation process but also gives you the ability to undo changes made when adding aggregation functions with just a few clicks.

Steps to Remove Aggregation Functions Without Grouped Columns:​

  1. Right-click on the added aggregation function.
  2. Choose the "None" option.
  3. Click on the "Summary" icon.

Summary with Group By​

Grid Designer allows the user to add aggregation functions to Grid reports when column grouping has been applied. These aggregation functions will be displayed at the end of each grouping in the report as a sub-total.

Steps to Apply Aggregation Functions With Grouped Columns:​

  1. Open Grid Designer.
  2. Create a new report or open an existing one.
  3. Agroup by a column.
  4. Click on the "Summary" icon.
  5. Right-click on the panel at the end of each group in the column where you want to apply an aggregation function.
  6. Choose the "Count" option.

The most impressive aspect is that Grid Designer goes further and provides the flexibility you need. This tool not only simplifies the report generation process but also gives you the ability to undo changes made when adding aggregation functions with just a few clicks.

Steps to Remove Aggregation Functions With Grouped Columns:​

  1. Right-click on the added aggregation function.
  2. Choose the "None" option.
  3. Click on the "Summary" icon.